from nCoVweb.ext import db




class SQLmodel(db.Model):
    __tablename__='city_data'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    city=db.Column(db.String(100))
    diagnosed=db.Column(db.Integer)
    suspected=db.Column(db.Integer)
    cured=db.Column(db.Integer)
    died=db.Column(db.Integer)
    uptime=db.Column(db.String(100))

class SQLtotal(db.Model):
    __tablename__='total_data'
    id=db.Column(db.Integer,primary_key=True,autoincrement=True)
    dates=db.Column(db.String(100))
    diagnosed = db.Column(db.Integer)
    suspected = db.Column(db.Integer)
    cured = db.Column(db.Integer)
    died = db.Column(db.Integer)

